{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "b12086d0",
   "metadata": {},
   "source": [
    "## 周边搜索"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "35d2cfaf",
   "metadata": {},
   "source": [
    "* url\n",
    "> https://restapi.amap.com/v3/place/around?parameters \n",
    "\n",
    "* 请求参数（两类）\n",
    "> 1、按照关键词搜索\n",
    "  2、按照查询POI类型"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d21591e3",
   "metadata": {},
   "source": [
    "### 1.关键词搜索"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "e1e314a7",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'113.678280,23.628439'"
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import requests # 调用 requests 模块\n",
    "\n",
    "geo_url = 'https://restapi.amap.com/v3/geocode/geo?parameters' # 请求的调用url\n",
    "\n",
    "# 请求方式：GET\n",
    "# 请求参数\n",
    "payload = {\n",
    "    'key':'aaa5520182ed361dc22933ce4acf40e6',\n",
    "    'address':'广东省广州市从化区广州南方学院'\n",
    "}\n",
    "\n",
    "# 发起请求\n",
    "r = requests.get(url = geo_url, params = payload)\n",
    "\n",
    "r.json()['geocodes'][0]['location']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "cf705f1a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'113.678280,23.628439'"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "NFU_location = r.json()['geocodes'][0]['location']\n",
    "NFU_location"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "1c18ee60",
   "metadata": {},
   "outputs": [],
   "source": [
    "para_url = 'https://restapi.amap.com/v3/place/around?parameters' # 请求的调用url\n",
    "\n",
    "payload = {\n",
    "    'key':'aaa5520182ed361dc22933ce4acf40e6',\n",
    "    'location':NFU_location ,\n",
    "    'types':'050100|050300|050201',\n",
    "    'page':'2',\n",
    "    'radius':'5000'\n",
    "}\n",
    "\n",
    "r = requests.get(url = para_url, params = payload)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "5c33069f",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "6d735784",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "      <th>10</th>\n",
       "      <th>11</th>\n",
       "      <th>12</th>\n",
       "      <th>13</th>\n",
       "      <th>14</th>\n",
       "      <th>15</th>\n",
       "      <th>16</th>\n",
       "      <th>17</th>\n",
       "      <th>18</th>\n",
       "      <th>19</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>parent</th>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>address</th>\n",
       "      <td>温泉镇广州南方学院商贸城二楼</td>\n",
       "      <td>温泉镇笃行路</td>\n",
       "      <td>南方学院商业中心一楼</td>\n",
       "      <td>广州南方学院</td>\n",
       "      <td>广州南方学院商业中心二楼</td>\n",
       "      <td>温泉镇笃行路20号中山大学南方学院商业中心三楼3F-032铺</td>\n",
       "      <td>温泉镇温泉大道882号广州南方学院商业中心一楼</td>\n",
       "      <td>中山大学南方学院</td>\n",
       "      <td>温泉大道886号中山大学南方学院内</td>\n",
       "      <td>温泉镇中大南方学院</td>\n",
       "      <td>温泉镇中大南方学院</td>\n",
       "      <td>温泉中大南方学院</td>\n",
       "      <td>温泉镇中大南方学院</td>\n",
       "      <td>温泉镇中大南方学院</td>\n",
       "      <td>温泉镇中大南方</td>\n",
       "      <td>温泉镇中大南方</td>\n",
       "      <td>温泉镇中大南方学院</td>\n",
       "      <td>温泉镇广州南方学院博学路6号三楼自编3号之13</td>\n",
       "      <td>温泉镇中山大学南方学院综合楼</td>\n",
       "      <td>温泉镇中山大学南方学院博学路6号西区食堂首层</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>distance</th>\n",
       "      <td>283</td>\n",
       "      <td>285</td>\n",
       "      <td>301</td>\n",
       "      <td>304</td>\n",
       "      <td>305</td>\n",
       "      <td>314</td>\n",
       "      <td>317</td>\n",
       "      <td>320</td>\n",
       "      <td>334</td>\n",
       "      <td>359</td>\n",
       "      <td>359</td>\n",
       "      <td>359</td>\n",
       "      <td>359</td>\n",
       "      <td>359</td>\n",
       "      <td>359</td>\n",
       "      <td>359</td>\n",
       "      <td>359</td>\n",
       "      <td>375</td>\n",
       "      <td>388</td>\n",
       "      <td>395</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>pname</th>\n",
       "      <td>广东省</td>\n",
       "      <td>广东省</td>\n",
       "      <td>广东省</td>\n",
       "      <td>广东省</td>\n",
       "      <td>广东省</td>\n",
       "      <td>广东省</td>\n",
       "      <td>广东省</td>\n",
       "      <td>广东省</td>\n",
       "      <td>广东省</td>\n",
       "      <td>广东省</td>\n",
       "      <td>广东省</td>\n",
       "      <td>广东省</td>\n",
       "      <td>广东省</td>\n",
       "      <td>广东省</td>\n",
       "      <td>广东省</td>\n",
       "      <td>广东省</td>\n",
       "      <td>广东省</td>\n",
       "      <td>广东省</td>\n",
       "      <td>广东省</td>\n",
       "      <td>广东省</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>importance</th>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>biz_type</th>\n",
       "      <td>diner</td>\n",
       "      <td>diner</td>\n",
       "      <td>diner</td>\n",
       "      <td>diner</td>\n",
       "      <td>diner</td>\n",
       "      <td>diner</td>\n",
       "      <td>diner</td>\n",
       "      <td>diner</td>\n",
       "      <td>diner</td>\n",
       "      <td>diner</td>\n",
       "      <td>diner</td>\n",
       "      <td>diner</td>\n",
       "      <td>diner</td>\n",
       "      <td>diner</td>\n",
       "      <td>diner</td>\n",
       "      <td>diner</td>\n",
       "      <td>diner</td>\n",
       "      <td>diner</td>\n",
       "      <td>diner</td>\n",
       "      <td>diner</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>cityname</th>\n",
       "      <td>广州市</td>\n",
       "      <td>广州市</td>\n",
       "      <td>广州市</td>\n",
       "      <td>广州市</td>\n",
       "      <td>广州市</td>\n",
       "      <td>广州市</td>\n",
       "      <td>广州市</td>\n",
       "      <td>广州市</td>\n",
       "      <td>广州市</td>\n",
       "      <td>广州市</td>\n",
       "      <td>广州市</td>\n",
       "      <td>广州市</td>\n",
       "      <td>广州市</td>\n",
       "      <td>广州市</td>\n",
       "      <td>广州市</td>\n",
       "      <td>广州市</td>\n",
       "      <td>广州市</td>\n",
       "      <td>广州市</td>\n",
       "      <td>广州市</td>\n",
       "      <td>广州市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>type</th>\n",
       "      <td>餐饮服务;快餐厅;快餐厅</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>餐饮服务;快餐厅;快餐厅</td>\n",
       "      <td>餐饮服务;快餐厅;快餐厅</td>\n",
       "      <td>餐饮服务;快餐厅;快餐厅</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>餐饮服务;快餐厅;快餐厅</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>餐饮服务;中餐厅;特色/地方风味餐厅</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>餐饮服务;快餐厅;快餐厅</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>餐饮服务;快餐厅;快餐厅</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>photos</th>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[{'title': [], 'url': 'https://img.alicdn.com/...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[{'title': [], 'url': 'http://store.is.autonav...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>typecode</th>\n",
       "      <td>050300</td>\n",
       "      <td>050100</td>\n",
       "      <td>050300</td>\n",
       "      <td>050300</td>\n",
       "      <td>050300</td>\n",
       "      <td>050100</td>\n",
       "      <td>050300</td>\n",
       "      <td>050100</td>\n",
       "      <td>050100</td>\n",
       "      <td>050100</td>\n",
       "      <td>050118</td>\n",
       "      <td>050100</td>\n",
       "      <td>050100</td>\n",
       "      <td>050100</td>\n",
       "      <td>050100</td>\n",
       "      <td>050100</td>\n",
       "      <td>050100</td>\n",
       "      <td>050300</td>\n",
       "      <td>050100</td>\n",
       "      <td>050300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>shopinfo</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>poiweight</th>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>childtype</th>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>adname</th>\n",
       "      <td>从化区</td>\n",
       "      <td>从化区</td>\n",
       "      <td>从化区</td>\n",
       "      <td>从化区</td>\n",
       "      <td>从化区</td>\n",
       "      <td>从化区</td>\n",
       "      <td>从化区</td>\n",
       "      <td>从化区</td>\n",
       "      <td>从化区</td>\n",
       "      <td>从化区</td>\n",
       "      <td>从化区</td>\n",
       "      <td>从化区</td>\n",
       "      <td>从化区</td>\n",
       "      <td>从化区</td>\n",
       "      <td>从化区</td>\n",
       "      <td>从化区</td>\n",
       "      <td>从化区</td>\n",
       "      <td>从化区</td>\n",
       "      <td>从化区</td>\n",
       "      <td>从化区</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>name</th>\n",
       "      <td>美乐佳汉堡</td>\n",
       "      <td>筷乐逸家</td>\n",
       "      <td>广州南方学院-小吃摊</td>\n",
       "      <td>广州南方学院-黄小厨煎饼果子</td>\n",
       "      <td>阪尚釜五谷鱼粉(广州南方学院店)</td>\n",
       "      <td>莫西多音乐餐吧(广州南方学院店)</td>\n",
       "      <td>杨国福麻辣烫(广州南方学院店)</td>\n",
       "      <td>桃姐靓汤(中大南方店)</td>\n",
       "      <td>鱼家风范</td>\n",
       "      <td>长沙一绝</td>\n",
       "      <td>壹号饺子馆(中大店)</td>\n",
       "      <td>淮南牛肉粉丝汤</td>\n",
       "      <td>食再添(中大店)</td>\n",
       "      <td>深海一只鱼(中大店)</td>\n",
       "      <td>莹香美食</td>\n",
       "      <td>湘锅锅香锅(中大店)</td>\n",
       "      <td>鱼诱(中大店)</td>\n",
       "      <td>一本美食店(中大云餐厅店)</td>\n",
       "      <td>王牌烤肉拌饭</td>\n",
       "      <td>肯德基(从化南方学院店)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>location</th>\n",
       "      <td>113.680172,23.630300</td>\n",
       "      <td>113.680147,23.630344</td>\n",
       "      <td>113.680073,23.630596</td>\n",
       "      <td>113.680378,23.630390</td>\n",
       "      <td>113.680413,23.630370</td>\n",
       "      <td>113.680352,23.630528</td>\n",
       "      <td>113.680480,23.630453</td>\n",
       "      <td>113.680188,23.630727</td>\n",
       "      <td>113.680590,23.630575</td>\n",
       "      <td>113.676568,23.631259</td>\n",
       "      <td>113.676568,23.631259</td>\n",
       "      <td>113.676568,23.631259</td>\n",
       "      <td>113.676568,23.631259</td>\n",
       "      <td>113.676568,23.631259</td>\n",
       "      <td>113.676568,23.631259</td>\n",
       "      <td>113.676568,23.631259</td>\n",
       "      <td>113.676568,23.631259</td>\n",
       "      <td>113.676339,23.631305</td>\n",
       "      <td>113.680126,23.631492</td>\n",
       "      <td>113.676231,23.631452</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tel</th>\n",
       "      <td>15013102859</td>\n",
       "      <td>15811600514</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>13527881190</td>\n",
       "      <td>15521386150</td>\n",
       "      <td>[]</td>\n",
       "      <td>17137629377</td>\n",
       "      <td>18825119618</td>\n",
       "      <td>[]</td>\n",
       "      <td>15802047085</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>13710639300</td>\n",
       "      <td>13543424701</td>\n",
       "      <td>19820396588</td>\n",
       "      <td>18933905760;15347382642</td>\n",
       "      <td>17322215812</td>\n",
       "      <td>4009200715</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>shopid</th>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>id</th>\n",
       "      <td>B0FFJ7XDGE</td>\n",
       "      <td>B0FFL7CP5J</td>\n",
       "      <td>B0HRVXHEDF</td>\n",
       "      <td>B0H0JSUKXZ</td>\n",
       "      <td>B0FFGT2QG2</td>\n",
       "      <td>B0FFL7ENDG</td>\n",
       "      <td>B0G3ZBMM2G</td>\n",
       "      <td>B0HRO7LCM1</td>\n",
       "      <td>B0HROCL270</td>\n",
       "      <td>B0HROCMY5T</td>\n",
       "      <td>B0HROCL9C0</td>\n",
       "      <td>B0HROCKTON</td>\n",
       "      <td>B0HROCK40Y</td>\n",
       "      <td>B0HRO7KVZA</td>\n",
       "      <td>B0H1MR1AGD</td>\n",
       "      <td>B0G2GMNM5K</td>\n",
       "      <td>B0FFL7MCT2</td>\n",
       "      <td>B0IUH6IEDZ</td>\n",
       "      <td>B0H1M7YDQH</td>\n",
       "      <td>B0H1YMW8PH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>biz_ext.cost</th>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>26.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>biz_ext.opentime2</th>\n",
       "      <td>每天10:30-14:00；每天16:30-23:30</td>\n",
       "      <td>09:00-21:00</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>10:00-22:30</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>07:00-23:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>biz_ext.rating</th>\n",
       "      <td>[]</td>\n",
       "      <td>3.9</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>3.6</td>\n",
       "      <td>3.6</td>\n",
       "      <td>4.0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>3.5</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>biz_ext.open_time</th>\n",
       "      <td>10:30-14:00 16:30-23:30</td>\n",
       "      <td>09:00-21:00</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>10:00-22:30</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>07:00-23:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>biz_ext.meal_ordering</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                                      0   \\\n",
       "parent                                                                []   \n",
       "address                                                   温泉镇广州南方学院商贸城二楼   \n",
       "distance                                                             283   \n",
       "pname                                                                广东省   \n",
       "importance                                                            []   \n",
       "biz_type                                                           diner   \n",
       "cityname                                                             广州市   \n",
       "type                                                        餐饮服务;快餐厅;快餐厅   \n",
       "photos                 [{'title': [], 'url': 'http://store.is.autonav...   \n",
       "typecode                                                          050300   \n",
       "shopinfo                                                               0   \n",
       "poiweight                                                             []   \n",
       "childtype                                                             []   \n",
       "adname                                                               从化区   \n",
       "name                                                               美乐佳汉堡   \n",
       "location                                            113.680172,23.630300   \n",
       "tel                                                          15013102859   \n",
       "shopid                                                                []   \n",
       "id                                                            B0FFJ7XDGE   \n",
       "biz_ext.cost                                                          []   \n",
       "biz_ext.opentime2                            每天10:30-14:00；每天16:30-23:30   \n",
       "biz_ext.rating                                                        []   \n",
       "biz_ext.open_time                                10:30-14:00 16:30-23:30   \n",
       "biz_ext.meal_ordering                                                  0   \n",
       "\n",
       "                                                                      1   \\\n",
       "parent                                                                []   \n",
       "address                                                           温泉镇笃行路   \n",
       "distance                                                             285   \n",
       "pname                                                                广东省   \n",
       "importance                                                            []   \n",
       "biz_type                                                           diner   \n",
       "cityname                                                             广州市   \n",
       "type                                                        餐饮服务;中餐厅;中餐厅   \n",
       "photos                 [{'title': [], 'url': 'http://store.is.autonav...   \n",
       "typecode                                                          050100   \n",
       "shopinfo                                                               1   \n",
       "poiweight                                                             []   \n",
       "childtype                                                             []   \n",
       "adname                                                               从化区   \n",
       "name                                                                筷乐逸家   \n",
       "location                                            113.680147,23.630344   \n",
       "tel                                                          15811600514   \n",
       "shopid                                                                []   \n",
       "id                                                            B0FFL7CP5J   \n",
       "biz_ext.cost                                                          []   \n",
       "biz_ext.opentime2                                            09:00-21:00   \n",
       "biz_ext.rating                                                       3.9   \n",
       "biz_ext.open_time                                            09:00-21:00   \n",
       "biz_ext.meal_ordering                                                  0   \n",
       "\n",
       "                                         2                     3   \\\n",
       "parent                                   []                    []   \n",
       "address                          南方学院商业中心一楼                广州南方学院   \n",
       "distance                                301                   304   \n",
       "pname                                   广东省                   广东省   \n",
       "importance                               []                    []   \n",
       "biz_type                              diner                 diner   \n",
       "cityname                                广州市                   广州市   \n",
       "type                           餐饮服务;快餐厅;快餐厅          餐饮服务;快餐厅;快餐厅   \n",
       "photos                                   []                    []   \n",
       "typecode                             050300                050300   \n",
       "shopinfo                                  0                     0   \n",
       "poiweight                                []                    []   \n",
       "childtype                                []                    []   \n",
       "adname                                  从化区                   从化区   \n",
       "name                             广州南方学院-小吃摊        广州南方学院-黄小厨煎饼果子   \n",
       "location               113.680073,23.630596  113.680378,23.630390   \n",
       "tel                                      []                    []   \n",
       "shopid                                   []                    []   \n",
       "id                               B0HRVXHEDF            B0H0JSUKXZ   \n",
       "biz_ext.cost                             []                    []   \n",
       "biz_ext.opentime2                        []                    []   \n",
       "biz_ext.rating                           []                    []   \n",
       "biz_ext.open_time                        []                    []   \n",
       "biz_ext.meal_ordering                     0                     0   \n",
       "\n",
       "                                         4                               5   \\\n",
       "parent                                   []                              []   \n",
       "address                        广州南方学院商业中心二楼  温泉镇笃行路20号中山大学南方学院商业中心三楼3F-032铺   \n",
       "distance                                305                             314   \n",
       "pname                                   广东省                             广东省   \n",
       "importance                               []                              []   \n",
       "biz_type                              diner                           diner   \n",
       "cityname                                广州市                             广州市   \n",
       "type                           餐饮服务;快餐厅;快餐厅                    餐饮服务;中餐厅;中餐厅   \n",
       "photos                                   []                              []   \n",
       "typecode                             050300                          050100   \n",
       "shopinfo                                  0                               0   \n",
       "poiweight                                []                              []   \n",
       "childtype                                []                              []   \n",
       "adname                                  从化区                             从化区   \n",
       "name                       阪尚釜五谷鱼粉(广州南方学院店)                莫西多音乐餐吧(广州南方学院店)   \n",
       "location               113.680413,23.630370            113.680352,23.630528   \n",
       "tel                                      []                     13527881190   \n",
       "shopid                                   []                              []   \n",
       "id                               B0FFGT2QG2                      B0FFL7ENDG   \n",
       "biz_ext.cost                             []                              []   \n",
       "biz_ext.opentime2                        []                              []   \n",
       "biz_ext.rating                          3.6                             3.6   \n",
       "biz_ext.open_time                        []                              []   \n",
       "biz_ext.meal_ordering                     0                               0   \n",
       "\n",
       "                                                                      6   \\\n",
       "parent                                                                []   \n",
       "address                                          温泉镇温泉大道882号广州南方学院商业中心一楼   \n",
       "distance                                                             317   \n",
       "pname                                                                广东省   \n",
       "importance                                                            []   \n",
       "biz_type                                                           diner   \n",
       "cityname                                                             广州市   \n",
       "type                                                        餐饮服务;快餐厅;快餐厅   \n",
       "photos                 [{'title': [], 'url': 'https://img.alicdn.com/...   \n",
       "typecode                                                          050300   \n",
       "shopinfo                                                               0   \n",
       "poiweight                                                             []   \n",
       "childtype                                                             []   \n",
       "adname                                                               从化区   \n",
       "name                                                     杨国福麻辣烫(广州南方学院店)   \n",
       "location                                            113.680480,23.630453   \n",
       "tel                                                          15521386150   \n",
       "shopid                                                                []   \n",
       "id                                                            B0G3ZBMM2G   \n",
       "biz_ext.cost                                                          []   \n",
       "biz_ext.opentime2                                            10:00-22:30   \n",
       "biz_ext.rating                                                       4.0   \n",
       "biz_ext.open_time                                            10:00-22:30   \n",
       "biz_ext.meal_ordering                                                  0   \n",
       "\n",
       "                                         7                     8   \\\n",
       "parent                                   []                    []   \n",
       "address                            中山大学南方学院     温泉大道886号中山大学南方学院内   \n",
       "distance                                320                   334   \n",
       "pname                                   广东省                   广东省   \n",
       "importance                               []                    []   \n",
       "biz_type                              diner                 diner   \n",
       "cityname                                广州市                   广州市   \n",
       "type                           餐饮服务;中餐厅;中餐厅          餐饮服务;中餐厅;中餐厅   \n",
       "photos                                   []                    []   \n",
       "typecode                             050100                050100   \n",
       "shopinfo                                  0                     0   \n",
       "poiweight                                []                    []   \n",
       "childtype                                []                    []   \n",
       "adname                                  从化区                   从化区   \n",
       "name                            桃姐靓汤(中大南方店)                  鱼家风范   \n",
       "location               113.680188,23.630727  113.680590,23.630575   \n",
       "tel                                      []           17137629377   \n",
       "shopid                                   []                    []   \n",
       "id                               B0HRO7LCM1            B0HROCL270   \n",
       "biz_ext.cost                             []                    []   \n",
       "biz_ext.opentime2                        []                    []   \n",
       "biz_ext.rating                           []                    []   \n",
       "biz_ext.open_time                        []                    []   \n",
       "biz_ext.meal_ordering                     0                     0   \n",
       "\n",
       "                                         9                     10  \\\n",
       "parent                                   []                    []   \n",
       "address                           温泉镇中大南方学院             温泉镇中大南方学院   \n",
       "distance                                359                   359   \n",
       "pname                                   广东省                   广东省   \n",
       "importance                               []                    []   \n",
       "biz_type                              diner                 diner   \n",
       "cityname                                广州市                   广州市   \n",
       "type                           餐饮服务;中餐厅;中餐厅    餐饮服务;中餐厅;特色/地方风味餐厅   \n",
       "photos                                   []                    []   \n",
       "typecode                             050100                050118   \n",
       "shopinfo                                  0                     0   \n",
       "poiweight                                []                    []   \n",
       "childtype                                []                    []   \n",
       "adname                                  从化区                   从化区   \n",
       "name                                   长沙一绝            壹号饺子馆(中大店)   \n",
       "location               113.676568,23.631259  113.676568,23.631259   \n",
       "tel                             18825119618                    []   \n",
       "shopid                                   []                    []   \n",
       "id                               B0HROCMY5T            B0HROCL9C0   \n",
       "biz_ext.cost                             []                    []   \n",
       "biz_ext.opentime2                        []                    []   \n",
       "biz_ext.rating                           []                    []   \n",
       "biz_ext.open_time                        []                    []   \n",
       "biz_ext.meal_ordering                     0                     0   \n",
       "\n",
       "                                         11                    12  \\\n",
       "parent                                   []                    []   \n",
       "address                            温泉中大南方学院             温泉镇中大南方学院   \n",
       "distance                                359                   359   \n",
       "pname                                   广东省                   广东省   \n",
       "importance                               []                    []   \n",
       "biz_type                              diner                 diner   \n",
       "cityname                                广州市                   广州市   \n",
       "type                           餐饮服务;中餐厅;中餐厅          餐饮服务;中餐厅;中餐厅   \n",
       "photos                                   []                    []   \n",
       "typecode                             050100                050100   \n",
       "shopinfo                                  0                     0   \n",
       "poiweight                                []                    []   \n",
       "childtype                                []                    []   \n",
       "adname                                  从化区                   从化区   \n",
       "name                                淮南牛肉粉丝汤              食再添(中大店)   \n",
       "location               113.676568,23.631259  113.676568,23.631259   \n",
       "tel                             15802047085                    []   \n",
       "shopid                                   []                    []   \n",
       "id                               B0HROCKTON            B0HROCK40Y   \n",
       "biz_ext.cost                             []                    []   \n",
       "biz_ext.opentime2                        []                    []   \n",
       "biz_ext.rating                           []                    []   \n",
       "biz_ext.open_time                        []                    []   \n",
       "biz_ext.meal_ordering                     0                     0   \n",
       "\n",
       "                                         13                    14  \\\n",
       "parent                                   []                    []   \n",
       "address                           温泉镇中大南方学院               温泉镇中大南方   \n",
       "distance                                359                   359   \n",
       "pname                                   广东省                   广东省   \n",
       "importance                               []                    []   \n",
       "biz_type                              diner                 diner   \n",
       "cityname                                广州市                   广州市   \n",
       "type                           餐饮服务;中餐厅;中餐厅          餐饮服务;中餐厅;中餐厅   \n",
       "photos                                   []                    []   \n",
       "typecode                             050100                050100   \n",
       "shopinfo                                  0                     0   \n",
       "poiweight                                []                    []   \n",
       "childtype                                []                    []   \n",
       "adname                                  从化区                   从化区   \n",
       "name                             深海一只鱼(中大店)                  莹香美食   \n",
       "location               113.676568,23.631259  113.676568,23.631259   \n",
       "tel                                      []           13710639300   \n",
       "shopid                                   []                    []   \n",
       "id                               B0HRO7KVZA            B0H1MR1AGD   \n",
       "biz_ext.cost                             []                    []   \n",
       "biz_ext.opentime2                        []                    []   \n",
       "biz_ext.rating                           []                    []   \n",
       "biz_ext.open_time                        []                    []   \n",
       "biz_ext.meal_ordering                     0                     0   \n",
       "\n",
       "                                         15                    16  \\\n",
       "parent                                   []                    []   \n",
       "address                             温泉镇中大南方             温泉镇中大南方学院   \n",
       "distance                                359                   359   \n",
       "pname                                   广东省                   广东省   \n",
       "importance                               []                    []   \n",
       "biz_type                              diner                 diner   \n",
       "cityname                                广州市                   广州市   \n",
       "type                           餐饮服务;中餐厅;中餐厅          餐饮服务;中餐厅;中餐厅   \n",
       "photos                                   []                    []   \n",
       "typecode                             050100                050100   \n",
       "shopinfo                                  0                     0   \n",
       "poiweight                                []                    []   \n",
       "childtype                                []                    []   \n",
       "adname                                  从化区                   从化区   \n",
       "name                             湘锅锅香锅(中大店)               鱼诱(中大店)   \n",
       "location               113.676568,23.631259  113.676568,23.631259   \n",
       "tel                             13543424701           19820396588   \n",
       "shopid                                   []                    []   \n",
       "id                               B0G2GMNM5K            B0FFL7MCT2   \n",
       "biz_ext.cost                             []                    []   \n",
       "biz_ext.opentime2                        []                    []   \n",
       "biz_ext.rating                           []                   3.5   \n",
       "biz_ext.open_time                        []                    []   \n",
       "biz_ext.meal_ordering                     0                     0   \n",
       "\n",
       "                                                                      17  \\\n",
       "parent                                                                []   \n",
       "address                                          温泉镇广州南方学院博学路6号三楼自编3号之13   \n",
       "distance                                                             375   \n",
       "pname                                                                广东省   \n",
       "importance                                                            []   \n",
       "biz_type                                                           diner   \n",
       "cityname                                                             广州市   \n",
       "type                                                        餐饮服务;快餐厅;快餐厅   \n",
       "photos                 [{'title': [], 'url': 'http://store.is.autonav...   \n",
       "typecode                                                          050300   \n",
       "shopinfo                                                               0   \n",
       "poiweight                                                             []   \n",
       "childtype                                                             []   \n",
       "adname                                                               从化区   \n",
       "name                                                       一本美食店(中大云餐厅店)   \n",
       "location                                            113.676339,23.631305   \n",
       "tel                                              18933905760;15347382642   \n",
       "shopid                                                                []   \n",
       "id                                                            B0IUH6IEDZ   \n",
       "biz_ext.cost                                                          []   \n",
       "biz_ext.opentime2                                                     []   \n",
       "biz_ext.rating                                                        []   \n",
       "biz_ext.open_time                                                     []   \n",
       "biz_ext.meal_ordering                                                  0   \n",
       "\n",
       "                                         18  \\\n",
       "parent                                   []   \n",
       "address                      温泉镇中山大学南方学院综合楼   \n",
       "distance                                388   \n",
       "pname                                   广东省   \n",
       "importance                               []   \n",
       "biz_type                              diner   \n",
       "cityname                                广州市   \n",
       "type                           餐饮服务;中餐厅;中餐厅   \n",
       "photos                                   []   \n",
       "typecode                             050100   \n",
       "shopinfo                                  0   \n",
       "poiweight                                []   \n",
       "childtype                                []   \n",
       "adname                                  从化区   \n",
       "name                                 王牌烤肉拌饭   \n",
       "location               113.680126,23.631492   \n",
       "tel                             17322215812   \n",
       "shopid                                   []   \n",
       "id                               B0H1M7YDQH   \n",
       "biz_ext.cost                             []   \n",
       "biz_ext.opentime2                        []   \n",
       "biz_ext.rating                           []   \n",
       "biz_ext.open_time                        []   \n",
       "biz_ext.meal_ordering                     0   \n",
       "\n",
       "                                                                      19  \n",
       "parent                                                                []  \n",
       "address                                           温泉镇中山大学南方学院博学路6号西区食堂首层  \n",
       "distance                                                             395  \n",
       "pname                                                                广东省  \n",
       "importance                                                            []  \n",
       "biz_type                                                           diner  \n",
       "cityname                                                             广州市  \n",
       "type                                                        餐饮服务;快餐厅;快餐厅  \n",
       "photos                 [{'title': [], 'url': 'http://store.is.autonav...  \n",
       "typecode                                                          050300  \n",
       "shopinfo                                                               0  \n",
       "poiweight                                                             []  \n",
       "childtype                                                             []  \n",
       "adname                                                               从化区  \n",
       "name                                                        肯德基(从化南方学院店)  \n",
       "location                                            113.676231,23.631452  \n",
       "tel                                                           4009200715  \n",
       "shopid                                                                []  \n",
       "id                                                            B0H1YMW8PH  \n",
       "biz_ext.cost                                                       26.00  \n",
       "biz_ext.opentime2                                            07:00-23:00  \n",
       "biz_ext.rating                                                       4.2  \n",
       "biz_ext.open_time                                            07:00-23:00  \n",
       "biz_ext.meal_ordering                                                  0  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.json_normalize(r.json()['pois']).T"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "cccabee0",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.8"
  },
  "toc": {
   "base_numbering": 1,
   "nav_menu": {},
   "number_sections": true,
   "sideBar": true,
   "skip_h1_title": false,
   "title_cell": "Table of Contents",
   "title_sidebar": "Contents",
   "toc_cell": false,
   "toc_position": {},
   "toc_section_display": true,
   "toc_window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}
